Edinburgh’s road network
Edinburgh’s implementation zones
Edinburgh’s control zones
Time series analysis
Mapping accidents with roads: 2013
## LAYER Accident_Index
## 1 20mph existing streets 48
## 2 20mph local streets 72
## 3 20mph main streets 182
## 4 30mph 98
## 5 40mph 43
## 6 50, 60 or 70mph 1
## 7 Part time 20mph 1
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 25
## 2 30 387
## 3 40 35
Mapping accidents with roads: 2014
## LAYER Accident_Index
## 1 20mph existing streets 154
## 2 20mph local streets 158
## 3 20mph main streets 389
## 4 30mph 266
## 5 40mph 68
## 6 50, 60 or 70mph 14
## 7 Part time 20mph 9
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 39
## 2 30 955
## 3 40 69
Mapping accidents with roads: 2015
## LAYER Accident_Index
## 1 20mph existing streets 106
## 2 20mph local streets 156
## 3 20mph main streets 327
## 4 30mph 254
## 5 40mph 80
## 6 50, 60 or 70mph 12
## 7 Part time 20mph 6
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 34
## 2 30 832
## 3 40 80
Mapping accidents with roads: 2016
## LAYER Accident_Index
## 1 20mph existing streets 48
## 2 20mph local streets 57
## 3 20mph main streets 25
## 4 30mph 28
## 5 40mph 17
## Speed_limit Accident_Index
## 1 20 8
## 2 30 148
## 3 40 19
Mapping accidents with roads: 2018
## LAYER Accident_Index
## 1 20mph existing streets 64
## 2 20mph local streets 83
## 3 20mph main streets 181
## 4 30mph 146
## 5 40mph 47
## 6 50, 60 or 70mph 5
## 7 Part time 20mph 7
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 289
## 2 30 191
## 3 40 55
Mapping accidents with roads: 2019
## LAYER Accident_Index
## 1 20mph existing streets 31
## 2 20mph local streets 52
## 3 20mph main streets 87
## 4 30mph 77
## 5 40mph 24
## 6 50, 60 or 70mph 2
## 7 Part time 20mph 1
## 8 Trunk roads 1
## Speed_limit Accident_Index
## 1 20 153
## 2 30 97
## 3 40 25
Count pre 20mph
## LAYER Accident_Index
## 1 20mph existing streets 356
## 2 20mph local streets 443
## 3 20mph main streets 923
## 4 30mph 646
## 5 40mph 208
## 6 50, 60 or 70mph 27
## 7 Part time 20mph 16
## 8 Trunk roads 12
## Speed_limit Accident_Index
## 1 20 106
## 2 30 2322
## 3 40 203
Count post 20mph
## LAYER Accident_Index
## 1 20mph existing streets 95
## 2 20mph local streets 135
## 3 20mph main streets 268
## 4 30mph 223
## 5 40mph 71
## 6 50, 60 or 70mph 7
## 7 Part time 20mph 8
## 8 Trunk roads 3
## Speed_limit Accident_Index
## 1 20 442
## 2 30 288
## 3 40 80
Output column: Layer
## ID Speed_limit LAYER
## 1 1509 30 30mph
## 2 987 30 20mph main streets
## 3 2505 30 30mph
## 4 1614 30 30mph
## 5 2355 30 30mph
## 6 153 30 20mph main streets
Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 30mph | 646 | 223 | 0.40 | 0.28 | 0.12 | 30.00 |
| Streets at 20mph | 356 | 95 | 0.22 | 0.12 | 0.10 | 45.45 |
| Streets at 30mph changed to 20mph | 1366 | 403 | 0.85 | 0.51 | 0.34 | 40.00 |
| Streets at 40mph | 208 | 71 | 0.13 | 0.09 | 0.04 | 30.77 |
| All streets | 1613 | 792 | 1.00 | 1.00 | 0.00 | 0.00 |
Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 20mph | 106 | 442 | 0.04 | 0.55 | -0.51 | -12.75 |
| Streets at 30mph | 2322 | 288 | 0.88 | 0.36 | 0.52 | 0.59 |
| Streets at 40mph | 203 | 80 | 0.08 | 0.10 | -0.02 | -0.25 |
| All streets | 2631 | 810 | 1.00 | 1.00 | 0.00 | 0.00 |
Effect estimate (GIS)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1054 | 966 | 611 | 810 |
| Effect estimate | 31.27 |
Effect estimate (Stats19)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1032 | 945 | 599 | 792 |
| Effect estimate | 31.36 |
Mapping accidents with implementation zones: 2013
## ImplementationZone Accident_Index
## 1 1 73
## 2 2 105
## 3 3 137
## 4 4 44
## 5 5 68
## 6 6 30
## 7 7 21
Mapping accidents with implementation zones: 2014
## ImplementationZone Accident_Index
## 1 1 168
## 2 2 275
## 3 3 298
## 4 4 109
## 5 5 132
## 6 6 89
## 7 7 58
Mapping accidents with implementation zones: 2015
## ImplementationZone Accident_Index
## 1 1 155
## 2 2 210
## 3 3 273
## 4 4 75
## 5 5 144
## 6 6 91
## 7 7 43
Mapping accidents with implementation zones: 2016
## ImplementationZone Accident_Index
## 1 1 96
## 2 2 120
## 3 3 147
## 4 4 48
## 5 5 60
## 6 6 48
## 7 7 24
Mapping accidents with implementation zones: 2018
## ImplementationZone Accident_Index
## 1 1 88
## 2 2 125
## 3 3 160
## 4 4 53
## 5 5 68
## 6 6 46
## 7 7 30
Mapping accidents with implementation zones: 2019
## ImplementationZone Accident_Index
## 1 1 42
## 2 2 68
## 3 3 79
## 4 4 33
## 5 5 27
## 6 6 18
## 7 7 14
Output column: Implementation Zone
## Accident_Index Speed_limit ImplementationZone
## 1 2013950000001 30 1
## 2 2013950000002 30 2
## 3 2013950000003 30 2
## 4 2013950000007 30 1
## 5 2013950000010 30 4
## 6 2013950000058 20 7
Total accidents per zone
## ImplementationZone Accident_Index
## 1 1 622
## 2 2 903
## 3 3 1094
## 4 4 362
## 5 5 499
## 6 6 322
## 7 7 190
Control zone 1a:City center –> George St/Harbour, Aberdeen
## [1] 81
Control zone 1b:Rural west –> Tay Bridgehead & St Andrews
## [1] 60
Control zone 3:South central –> Dundee
## [1] 494
Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West
## [1] 286
Control zone 5:West –> Glasgow Kelvin
## [1] 977
Control zone 6:South –> Paisley
## [1] 391
Updated dataset for Edinburgh
## Accident_Index Speed_limit LAYER ImplementationZone
## 1 0000419 20 20mph main streets 2
## 2 0000519 20 20mph local streets 1
## 3 0000919 40 20mph local streets 3
## 4 0001019 20 30mph 2
## 5 0001219 40 40mph 4
## 6 0001419 30 30mph 4